object frmInversor: TfrmInversor
  Left = 442
  Top = 147
  Width = 420
  Height = 293
  Caption = 'Inversiones por Inversor'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnClose = FormClose
  DesignSize = (
    412
    263)
  PixelsPerInch = 96
  TextHeight = 13
  object lblFechaIni: TLabel
    Left = 12
    Top = 11
    Width = 28
    Height = 13
    Caption = 'Inicio:'
  end
  object lblFechaFin: TLabel
    Left = 177
    Top = 11
    Width = 25
    Height = 13
    Caption = 'Final:'
  end
  object DBText1: TDBText
    Left = 149
    Top = 237
    Width = 42
    Height = 13
    Alignment = taRightJustify
    AutoSize = True
    DataField = 'total'
    DataSource = s
  end
  object Label2: TLabel
    Left = 10
    Top = 237
    Width = 88
    Height = 13
    Anchors = [akLeft, akBottom]
    Caption = 'Total Invertido:'
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clNavy
    Font.Height = -11
    Font.Name = 'MS Sans Serif'
    Font.Style = [fsBold]
    ParentFont = False
  end
  object edtFechaIni: TDateEdit
    Left = 72
    Top = 5
    Width = 75
    Height = 21
    Ctl3D = False
    DefaultToday = True
    DialogTitle = 'Seleccione una Fecha'
    NumGlyphs = 2
    ParentCtl3D = False
    YearDigits = dyTwo
    TabOrder = 0
    Text = '07/12/06'
  end
  object edtFechaFin: TDateEdit
    Left = 226
    Top = 5
    Width = 95
    Height = 21
    Ctl3D = False
    DefaultToday = True
    NumGlyphs = 2
    ParentCtl3D = False
    YearDigits = dyTwo
    TabOrder = 1
    Text = '07/12/06'
  end
  object grdInversion: TRxDBGrid
    Left = 8
    Top = 32
    Width = 397
    Height = 198
    Anchors = [akLeft, akTop, akRight, akBottom]
    DataSource = s
    TabOrder = 2
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    OnTitleClick = grdInversionTitleClick
    Columns = <
      item
        Expanded = False
        FieldName = 'CONCATENATION'
        Title.Alignment = taCenter
        Title.Caption = 'Inversor'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clNavy
        Title.Font.Height = -11
        Title.Font.Name = 'MS Sans Serif'
        Title.Font.Style = [fsBold]
        Width = 251
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'SUM'
        Title.Alignment = taCenter
        Title.Caption = 'Inversi'#243'n'
        Title.Font.Charset = DEFAULT_CHARSET
        Title.Font.Color = clNavy
        Title.Font.Height = -11
        Title.Font.Name = 'MS Sans Serif'
        Title.Font.Style = [fsBold]
        Width = 97
        Visible = True
      end>
  end
  object btnCargar: TButton
    Left = 329
    Top = 234
    Width = 75
    Height = 25
    Anchors = [akRight, akBottom]
    Caption = 'Cargar'
    TabOrder = 3
    OnClick = btnCargarClick
  end
  object cds: TSQLClientDataSet
    CommandText = 
      'SELECT I.ID_INVERSOR, I.APELLIDO||'#39', '#39'|| I.NOMBRE, sum(CI.MONTO)' +
      #13#10'FROM INVERSOR AS I INNER JOIN COBRO_INVERSOR AS CI ON (I.ID_IN' +
      'VERSOR = CI.ID_INVERSOR)'#13#10'WHERE CI.FECHA <= :fechaFin AND CI.FEC' +
      'HA >= :fechaIni '#13#10'GROUP BY I.ID_INVERSOR, I.APELLIDO, I.NOMBRE'#13#10
    Aggregates = <>
    AggregatesActive = True
    Options = [poAllowCommandText]
    ObjectView = True
    Params = <
      item
        DataType = ftUnknown
        Name = 'fechaFin'
        ParamType = ptInput
      end
      item
        DataType = ftUnknown
        Name = 'fechaIni'
        ParamType = ptInput
      end>
    DBConnection = Datos.Con
    Left = 16
    Top = 192
    object cdsID_INVERSOR: TSmallintField
      FieldName = 'ID_INVERSOR'
      Required = True
    end
    object cdsCONCATENATION: TStringField
      FieldName = 'CONCATENATION'
      Size = 52
    end
    object cdsSUM: TFloatField
      FieldName = 'SUM'
      DisplayFormat = '#,###,###,##0.00'
    end
    object cdstotal: TAggregateField
      FieldName = 'total'
      Active = True
      DisplayFormat = '#,###,###,##0.00'
      Expression = 'sum(sum)'
    end
  end
  object s: TDataSource
    DataSet = cds
    Left = 48
    Top = 192
  end
end
